/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package queenb.web.store;

import java.sql.Date;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import oracle.jdbc.OracleTypes;
import queenb.net.datacontrol.DataStatement;
import queenb.net.entitybean.V500;
import queenb.web.inteface.V500Inf;
import queenb.web.util.PackageContants;

/**
 *
 * @author Nguyen Hung
 */
public class V500Store extends V500 implements V500Inf {

    @Override
    public int updateV500By(int pnPV500,
            int pnFH000,
            int pnFH200,
            int pnFV050,
            int pnFS200,
            int pnFV200,
            int pnFK100,
            String pvVV501,
            String pvVV502,
            String pvVV503,
            String pvVV504,
            String pvVV505,
            String pvVV506,
            double pnVN507,
            int pnVN508,
            double pnVN509,
            int pnVN510,
            double pnVN511,
            int pnVN512,
            double pnVN513,
            int pnVN514,
            double pnVN515,
            String pvFS400,
            String pvFS410,
            String pvFS420,
            String pvFS430,
            String pvFS440,
            String pvFS450,
            String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.UPDATE_V500, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV500),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFK100),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV501),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV502),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV503),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV504),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV505),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV506),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN507),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN508),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN509),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN510),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN511),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN512),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN513),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN514),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN515),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvFS400),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvFS410),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvFS420),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvFS430),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvFS440),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvFS450),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }
    }

    @Override
    public int deleteV500By(int pnPV500, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.DELETE_V500, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV500),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.update(dataStatement, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }
    }

    @Override
    public List<V500> getListV500ByFS200(int pnFH000,
            int pnFH200,
            int pnFV050,
            int pnFS200,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V500, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public List<V500> getListCombV050SGT(int pnFH000, int pnFH200, String pvVV051, String pvVV066, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_COMBV050SGT1, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV066),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public int updateV050By(int pnPV050,
            int pnFH000,
            int pnFH200,
            int pnFS200,
            String pvVV051,
            String pvVV052,
            int pnVN053,
            int pnVN054,
            double pnVN055,
            int pnVN056,
            int pnVN057,
            double pnVN058,
            int pnVN059,
            int pnVN060,
            double pnVN061,
            int pnVN062,
            int pnVN063,
            double pnVN064,
            String pnVN065,
            String pnVN066,
            String pnVV069,
            String pnVV070,
            String pnVV071,
            int pnVN072,
            String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.UPDATE_V050, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV052),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN053),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN054),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN055),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN056),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN057),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN058),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN059),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN060),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN061),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN062),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN063),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN064),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN065),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN066),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV069),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV070),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV071),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN072),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }

    }

    @Override
    public int updateV050(int pnPV050,
            int pnFH000,
            int pnFH200,
            int pnFS200,
            String pvVV051,
            String pvVV052,
            int pnVN053,
            int pnVN054,
            double pnVN055,
            int pnVN056,
            int pnVN057,
            double pnVN058,
            int pnVN059,
            int pnVN060,
            double pnVN061,
            int pnVN062,
            int pnVN063,
            double pnVN064,
            String pnVN065,
            String pnVN066,
            String pnVV069,
            String pnVV070,
            String pnVV071,
            int pnVN072,
            Date pnVD073,
            Date pnVD074,
            String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.UPDATE_V050_SGT, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV052),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN053),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN054),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN055),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN056),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN057),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN058),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN059),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN060),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN061),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN062),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN063),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN064),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN065),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN066),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV069),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV070),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV071),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN072),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pnVD073),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pnVD074),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }
    }

    @Override
    public List<V500> getListV050SGT(int pnFH000, int pnFH200, int pnFV050, int pnFS200, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V500, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    @Override
    public int CONTROTABV050(int pnPV050, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.CONTROTABV050, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.update(dataStatement, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }
    }

    public int CONFIRTABV050(int pnPV050, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.CONFIRTABV050, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.update(dataStatement, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }
    }

    public int CORRECTTABV050(int pnPV050,
            int pnFH000,
            int pnFH200,
            int pnFS200,
            String pvVV051,
            String pvVV052,
            int pnVN053,
            int pnVN054,
            double pnVN055,
            int pnVN056,
            int pnVN057,
            double pnVN058,
            int pnVN059,
            int pnVN060,
            double pnVN061,
            int pnVN062,
            int pnVN063,
            double pnVN064,
            String pvVV065,
            String pvVV066,
            String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.CORRECTTABV050, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV052),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN053),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN054),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN055),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN056),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN057),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN058),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN059),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN060),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN061),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN062),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN063),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN064),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV065),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV066),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }

    }

    public List<V500> getListV500R(int pnFH000, int pnFH200, int pnFV050, int pnVERS, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V500R, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVERS),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public int updateV050End(int pnPV050, int pnFH000, int pnFH200, int pnFS200, String pvVV051, String pvVV052, int pnVN053, int pnVN054, double pnVN055, int pnVN056, int pnVN057, double pnVN058, int pnVN059, int pnVN060, double pnVN061, int pnVN062, int pnVN063, double pnVN064, String pnVN065, String pnVN066,String pnVV067, String pnVV069, String pnVV070, String pnVV071, int pnVN072, Date pnVD073, Date pnVD074, int pnPV075, int pnPV076, int pnPV077, int pnPV078, int pnPN079, int pnA000F, int pnA000T, String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.UPDATE_V050_END, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV052),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN053),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN054),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN055),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN056),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN057),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN058),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN059),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN060),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN061),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN062),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN063),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN064),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN065),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN066),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV067),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV069),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV070),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV071),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN072),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pnVD073),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pnVD074),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV075),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV076),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV077),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV078),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPN079),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnA000F),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnA000T),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V500.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }
    }

    
}
